﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="NewDist" targetNamespace="http://tempuri.org/NewDist.xsd" xmlns:mstns="http://tempuri.org/NewDist.xsd" xmlns="http://tempuri.org/NewDist.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="DIAptekaConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="DIAptekaConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DIProject.Properties.Settings.GlobalReference.Default.DIAptekaConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GoodTableAdapter" GeneratorDataComponentClassName="GoodTableAdapter" Name="Good" UserDataComponentName="GoodTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     CA.Goods.Id, CA.Goods.AssortmentId, CA.Goods.ManufacturerId, CA.Goods.CountryId, CA.Goods.WholesalePack, CA.Goods.RetailPack, 
                      CA.Goods.AllowUnPack, CA.Goods.ManufactureBarCode, CA.Goods.Note, CA.Goods.MD, CA.Goods.MW, CA.Goods.FixedPrice, CA.Assortment.Name, 
                      CO.Countries.Name AS CountryName, CO.Manufacturers.Name AS ManufactureName, CA.Goods.ToDelete, CA.Goods.DefekturaAggregate, 
                      CA.Goods.ChildId, vwGoodsDetailed.FullName AS ChildName
FROM         CA.Goods INNER JOIN
                      CA.Assortment ON CA.Goods.AssortmentId = CA.Assortment.Id INNER JOIN
                      CO.Countries ON CA.Goods.CountryId = CO.Countries.Id INNER JOIN
                      CO.Manufacturers ON CA.Goods.ManufacturerId = CO.Manufacturers.Id LEFT OUTER JOIN
                      vwGoodsDetailed ON CA.Goods.ChildId = vwGoodsDetailed.Id
WHERE     (CA.Goods.Id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="Id" DataSourceName="DilanOstankino.CA.Goods" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="AssortmentId" DataSetColumn="AssortmentId" />
              <Mapping SourceColumn="ManufacturerId" DataSetColumn="ManufacturerId" />
              <Mapping SourceColumn="CountryId" DataSetColumn="CountryId" />
              <Mapping SourceColumn="WholesalePack" DataSetColumn="WholesalePack" />
              <Mapping SourceColumn="RetailPack" DataSetColumn="RetailPack" />
              <Mapping SourceColumn="AllowUnPack" DataSetColumn="AllowUnPack" />
              <Mapping SourceColumn="ManufactureBarCode" DataSetColumn="ManufactureBarCode" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="FixedPrice" DataSetColumn="FixedPrice" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="CountryName" DataSetColumn="CountryName" />
              <Mapping SourceColumn="ManufactureName" DataSetColumn="ManufactureName" />
              <Mapping SourceColumn="ToDelete" DataSetColumn="ToDelete" />
              <Mapping SourceColumn="DefekturaAggregate" DataSetColumn="DefekturaAggregate" />
              <Mapping SourceColumn="ChildId" DataSetColumn="ChildId" />
              <Mapping SourceColumn="ChildName" DataSetColumn="ChildName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AssortmentTableAdapter" GeneratorDataComponentClassName="AssortmentTableAdapter" Name="Assortment" UserDataComponentName="AssortmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     CA.Assortment.Id, CA.Assortment.Name, CO.AssessmentGroup.Name AS AssessmentGroupName, CO.Catalog.Name AS CatalogName, 
                      CO.MedForm.Name AS MedFormName, CA.Assortment.ABList, CA.Assortment.NotPatentedRus, CA.Assortment.NotPatentedLat, CA.Assortment.GNVLS, 
                      CA.Assortment.Mandatory, CA.Assortment.StoreTemperature, CA.Assortment.BeforeOverdue, CA.Assortment.NoRecipe, CA.Assortment.ReferentPrice, 
                      CA.Assortment.ReferentDate, CA.Assortment.Note, CA.Assortment.MD, CA.Assortment.MW, CA.Assortment.ToDelete, CA.Assortment.MedFormId, 
                      CA.Assortment.AssesmentGroupId, CA.Assortment.CatalogId
FROM         CA.Assortment INNER JOIN
                      CO.AssessmentGroup ON CA.Assortment.AssesmentGroupId = CO.AssessmentGroup.Id INNER JOIN
                      CO.Catalog ON CA.Assortment.CatalogId = CO.Catalog.Id INNER JOIN
                      CO.MedForm ON CA.Assortment.MedFormId = CO.MedForm.Id
WHERE     (CA.Assortment.Id = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="id" ColumnName="Id" DataSourceName="DilanOstankino.CA.Assortment" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="AssessmentGroupName" DataSetColumn="AssessmentGroupName" />
              <Mapping SourceColumn="CatalogName" DataSetColumn="CatalogName" />
              <Mapping SourceColumn="MedFormName" DataSetColumn="MedFormName" />
              <Mapping SourceColumn="ABList" DataSetColumn="ABList" />
              <Mapping SourceColumn="NotPatentedRus" DataSetColumn="NotPatentedRus" />
              <Mapping SourceColumn="NotPatentedLat" DataSetColumn="NotPatentedLat" />
              <Mapping SourceColumn="GNVLS" DataSetColumn="GNVLS" />
              <Mapping SourceColumn="Mandatory" DataSetColumn="Mandatory" />
              <Mapping SourceColumn="StoreTemperature" DataSetColumn="StoreTemperature" />
              <Mapping SourceColumn="BeforeOverdue" DataSetColumn="BeforeOverdue" />
              <Mapping SourceColumn="NoRecipe" DataSetColumn="NoRecipe" />
              <Mapping SourceColumn="ReferentPrice" DataSetColumn="ReferentPrice" />
              <Mapping SourceColumn="ReferentDate" DataSetColumn="ReferentDate" />
              <Mapping SourceColumn="Note" DataSetColumn="Note" />
              <Mapping SourceColumn="MD" DataSetColumn="MD" />
              <Mapping SourceColumn="MW" DataSetColumn="MW" />
              <Mapping SourceColumn="ToDelete" DataSetColumn="ToDelete" />
              <Mapping SourceColumn="MedFormId" DataSetColumn="MedFormId" />
              <Mapping SourceColumn="AssesmentGroupId" DataSetColumn="AssesmentGroupId" />
              <Mapping SourceColumn="CatalogId" DataSetColumn="CatalogId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="DIAptekaConnectionString (Settings)" DbObjectName="DilanOstankino.dbo.AssortmentInsert" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="AssortmentInsert" MethodsParameterType="CLR" Modifier="Public" Name="AssortmentInsert" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="AssortmentInsert">
            <SelectCommand>
              <DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
                <CommandText>dbo.AssortmentInsert</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CatalogId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="150" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MedFormId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AssesmentGroupId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@ABList" Precision="0" ProviderType="Char" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NotPatentedRus" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NotPatentedLat" Precision="0" ProviderType="VarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@GNVLS" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Mandatory" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StoreTemperature" Precision="0" ProviderType="VarChar" Scale="0" Size="20" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input" ParameterName="@BeforeOverdue" Precision="3" ProviderType="TinyInt" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NoRecipe" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@ReferentPrice" Precision="19" ProviderType="Decimal" Scale="2" Size="9" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ReferentDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Note" Precision="0" ProviderType="VarChar" Scale="0" Size="250" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MD" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                  <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MW" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="NewDist" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="NewDist" msprop:Generator_DataSetName="NewDist">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Good" msprop:Generator_UserTableName="Good" msprop:Generator_RowDeletedName="GoodRowDeleted" msprop:Generator_RowChangedName="GoodRowChanged" msprop:Generator_RowClassName="GoodRow" msprop:Generator_RowChangingName="GoodRowChanging" msprop:Generator_RowEvArgName="GoodRowChangeEvent" msprop:Generator_RowEvHandlerName="GoodRowChangeEventHandler" msprop:Generator_TableClassName="GoodDataTable" msprop:Generator_TableVarName="tableGood" msprop:Generator_RowDeletingName="GoodRowDeleting" msprop:Generator_TablePropName="Good">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="AssortmentId" msprop:Generator_UserColumnName="AssortmentId" msprop:Generator_ColumnVarNameInTable="columnAssortmentId" msprop:Generator_ColumnPropNameInRow="AssortmentId" msprop:Generator_ColumnPropNameInTable="AssortmentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ManufacturerId" msprop:Generator_UserColumnName="ManufacturerId" msprop:Generator_ColumnVarNameInTable="columnManufacturerId" msprop:Generator_ColumnPropNameInRow="ManufacturerId" msprop:Generator_ColumnPropNameInTable="ManufacturerIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CountryId" msprop:Generator_UserColumnName="CountryId" msprop:Generator_ColumnVarNameInTable="columnCountryId" msprop:Generator_ColumnPropNameInRow="CountryId" msprop:Generator_ColumnPropNameInTable="CountryIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="WholesalePack" msprop:Generator_UserColumnName="WholesalePack" msprop:Generator_ColumnVarNameInTable="columnWholesalePack" msprop:Generator_ColumnPropNameInRow="WholesalePack" msprop:Generator_ColumnPropNameInTable="WholesalePackColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RetailPack" msprop:Generator_UserColumnName="RetailPack" msprop:Generator_ColumnVarNameInTable="columnRetailPack" msprop:Generator_ColumnPropNameInRow="RetailPack" msprop:Generator_ColumnPropNameInTable="RetailPackColumn" type="xs:int" minOccurs="0" />
              <xs:element name="AllowUnPack" msprop:Generator_UserColumnName="AllowUnPack" msprop:Generator_ColumnVarNameInTable="columnAllowUnPack" msprop:Generator_ColumnPropNameInRow="AllowUnPack" msprop:Generator_ColumnPropNameInTable="AllowUnPackColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ManufactureBarCode" msprop:Generator_UserColumnName="ManufactureBarCode" msprop:Generator_ColumnVarNameInTable="columnManufactureBarCode" msprop:Generator_ColumnPropNameInRow="ManufactureBarCode" msprop:Generator_ColumnPropNameInTable="ManufactureBarCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="13" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FixedPrice" msprop:Generator_UserColumnName="FixedPrice" msprop:Generator_ColumnVarNameInTable="columnFixedPrice" msprop:Generator_ColumnPropNameInRow="FixedPrice" msprop:Generator_ColumnPropNameInTable="FixedPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryName" msprop:Generator_UserColumnName="CountryName" msprop:Generator_ColumnVarNameInTable="columnCountryName" msprop:Generator_ColumnPropNameInRow="CountryName" msprop:Generator_ColumnPropNameInTable="CountryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufactureName" msprop:Generator_UserColumnName="ManufactureName" msprop:Generator_ColumnVarNameInTable="columnManufactureName" msprop:Generator_ColumnPropNameInRow="ManufactureName" msprop:Generator_ColumnPropNameInTable="ManufactureNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ToDelete" msprop:Generator_UserColumnName="ToDelete" msprop:Generator_ColumnVarNameInTable="columnToDelete" msprop:Generator_ColumnPropNameInRow="ToDelete" msprop:Generator_ColumnPropNameInTable="ToDeleteColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DefekturaAggregate" msprop:Generator_UserColumnName="DefekturaAggregate" msprop:Generator_ColumnVarNameInTable="columnDefekturaAggregate" msprop:Generator_ColumnPropNameInRow="DefekturaAggregate" msprop:Generator_ColumnPropNameInTable="DefekturaAggregateColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ChildId" msprop:Generator_UserColumnName="ChildId" msprop:Generator_ColumnVarNameInTable="columnChildId" msprop:Generator_ColumnPropNameInRow="ChildId" msprop:Generator_ColumnPropNameInTable="ChildIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ChildName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ChildName" msprop:Generator_ColumnVarNameInTable="columnChildName" msprop:Generator_ColumnPropNameInRow="ChildName" msprop:Generator_ColumnPropNameInTable="ChildNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="213" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Assortment" msprop:Generator_UserTableName="Assortment" msprop:Generator_RowDeletedName="AssortmentRowDeleted" msprop:Generator_RowChangedName="AssortmentRowChanged" msprop:Generator_RowClassName="AssortmentRow" msprop:Generator_RowChangingName="AssortmentRowChanging" msprop:Generator_RowEvArgName="AssortmentRowChangeEvent" msprop:Generator_RowEvHandlerName="AssortmentRowChangeEventHandler" msprop:Generator_TableClassName="AssortmentDataTable" msprop:Generator_TableVarName="tableAssortment" msprop:Generator_RowDeletingName="AssortmentRowDeleting" msprop:Generator_TablePropName="Assortment">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AssessmentGroupName" msprop:Generator_UserColumnName="AssessmentGroupName" msprop:Generator_ColumnVarNameInTable="columnAssessmentGroupName" msprop:Generator_ColumnPropNameInRow="AssessmentGroupName" msprop:Generator_ColumnPropNameInTable="AssessmentGroupNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CatalogName" msprop:Generator_UserColumnName="CatalogName" msprop:Generator_ColumnVarNameInTable="columnCatalogName" msprop:Generator_ColumnPropNameInRow="CatalogName" msprop:Generator_ColumnPropNameInTable="CatalogNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MedFormName" msprop:Generator_UserColumnName="MedFormName" msprop:Generator_ColumnVarNameInTable="columnMedFormName" msprop:Generator_ColumnPropNameInRow="MedFormName" msprop:Generator_ColumnPropNameInTable="MedFormNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ABList" msprop:Generator_UserColumnName="ABList" msprop:Generator_ColumnVarNameInTable="columnABList" msprop:Generator_ColumnPropNameInRow="ABList" msprop:Generator_ColumnPropNameInTable="ABListColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NotPatentedRus" msprop:Generator_UserColumnName="NotPatentedRus" msprop:Generator_ColumnVarNameInTable="columnNotPatentedRus" msprop:Generator_ColumnPropNameInRow="NotPatentedRus" msprop:Generator_ColumnPropNameInTable="NotPatentedRusColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NotPatentedLat" msprop:Generator_UserColumnName="NotPatentedLat" msprop:Generator_ColumnVarNameInTable="columnNotPatentedLat" msprop:Generator_ColumnPropNameInRow="NotPatentedLat" msprop:Generator_ColumnPropNameInTable="NotPatentedLatColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GNVLS" msprop:Generator_UserColumnName="GNVLS" msprop:Generator_ColumnVarNameInTable="columnGNVLS" msprop:Generator_ColumnPropNameInRow="GNVLS" msprop:Generator_ColumnPropNameInTable="GNVLSColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Mandatory" msprop:Generator_UserColumnName="Mandatory" msprop:Generator_ColumnVarNameInTable="columnMandatory" msprop:Generator_ColumnPropNameInRow="Mandatory" msprop:Generator_ColumnPropNameInTable="MandatoryColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="StoreTemperature" msprop:Generator_UserColumnName="StoreTemperature" msprop:Generator_ColumnVarNameInTable="columnStoreTemperature" msprop:Generator_ColumnPropNameInRow="StoreTemperature" msprop:Generator_ColumnPropNameInTable="StoreTemperatureColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BeforeOverdue" msprop:Generator_UserColumnName="BeforeOverdue" msprop:Generator_ColumnVarNameInTable="columnBeforeOverdue" msprop:Generator_ColumnPropNameInRow="BeforeOverdue" msprop:Generator_ColumnPropNameInTable="BeforeOverdueColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="NoRecipe" msprop:Generator_UserColumnName="NoRecipe" msprop:Generator_ColumnVarNameInTable="columnNoRecipe" msprop:Generator_ColumnPropNameInRow="NoRecipe" msprop:Generator_ColumnPropNameInTable="NoRecipeColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ReferentPrice" msprop:Generator_UserColumnName="ReferentPrice" msprop:Generator_ColumnVarNameInTable="columnReferentPrice" msprop:Generator_ColumnPropNameInRow="ReferentPrice" msprop:Generator_ColumnPropNameInTable="ReferentPriceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ReferentDate" msprop:Generator_UserColumnName="ReferentDate" msprop:Generator_ColumnVarNameInTable="columnReferentDate" msprop:Generator_ColumnPropNameInRow="ReferentDate" msprop:Generator_ColumnPropNameInTable="ReferentDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Note" msprop:Generator_UserColumnName="Note" msprop:Generator_ColumnVarNameInTable="columnNote" msprop:Generator_ColumnPropNameInRow="Note" msprop:Generator_ColumnPropNameInTable="NoteColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MD" msprop:Generator_UserColumnName="MD" msprop:Generator_ColumnVarNameInTable="columnMD" msprop:Generator_ColumnPropNameInRow="MD" msprop:Generator_ColumnPropNameInTable="MDColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MW" msprop:Generator_UserColumnName="MW" msprop:Generator_ColumnVarNameInTable="columnMW" msprop:Generator_ColumnPropNameInRow="MW" msprop:Generator_ColumnPropNameInTable="MWColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ToDelete" msprop:Generator_UserColumnName="ToDelete" msprop:Generator_ColumnVarNameInTable="columnToDelete" msprop:Generator_ColumnPropNameInRow="ToDelete" msprop:Generator_ColumnPropNameInTable="ToDeleteColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="MedFormId" msprop:Generator_UserColumnName="MedFormId" msprop:Generator_ColumnVarNameInTable="columnMedFormId" msprop:Generator_ColumnPropNameInRow="MedFormId" msprop:Generator_ColumnPropNameInTable="MedFormIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="AssesmentGroupId" msprop:Generator_UserColumnName="AssesmentGroupId" msprop:Generator_ColumnVarNameInTable="columnAssesmentGroupId" msprop:Generator_ColumnPropNameInRow="AssesmentGroupId" msprop:Generator_ColumnPropNameInTable="AssesmentGroupIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="CatalogId" msprop:Generator_UserColumnName="CatalogId" msprop:Generator_ColumnVarNameInTable="columnCatalogId" msprop:Generator_ColumnPropNameInRow="CatalogId" msprop:Generator_ColumnPropNameInTable="CatalogIdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>